insert overwrite table yl_ods.yl_tmsnew_tms_shipment partition(dt)
select
id
,shipment_no
,vehicleline_type
,business_attribute
,shipment_name
,vehicleline_id
,vehicleline_code
,vehicleline_name
,shifts
,transport_type
,operation_model
,vehicle_groupid
,vehicle_typegroup
,start_id
,start_code
,start_name
,end_id
,end_code
,end_name
,cnt
,mileage
,total_runtime
,total_intransittime
,span_days
,standard_speed
,planned_departure_time
,planned_arrival_time
,actual_departure_time
,actual_arrival_time
,shipment_state
,apply_reason
,audit_status
,audit_remark
,audit_id
,auditer
,audit_date
,vehicle_class_id
,vehicle_class_name
,plate_number
,trailer_number
,carrier_id
,carrier_type
,carrier_name
,vehicletype_id
,vehicletype_name
,load_weight
,vehicle_door_cnt
,null as driver_name
,null as driver_contact
,shipment_type
,quotation_model
,create_by
,create_by_name
,create_time
,update_by
,update_by_name
,update_time
,apply_reason_item
,pic_path
,pic_adr
,promotion
,overtime_type
,overtime_reasons
,ori_reg_shift_carrier_id
,freight_generate_status
,billing_way
,settlement_vehicle_type_id
,settlement_vehicle_type_name
,car_apply_code
,bidding_demand_code
,dt
from jms_ods.yl_tmsnew_tms_shipment
where dt = '{{ execution_date | cst_ds }}' ;